This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
Sub Click(Source As Button)
'Presuming the key value is unique, and that you can create a hidden view called "(keylookup)" with the key value in
'the first column, which is sorted
Dim session As New NotesSession
Dim ws As New notesuiworkspace
Dim uidoc As notesuidocument
Dim db As NotesDatabase
Dim view As NotesView
Dim doc As NotesDocument
Dim lookupkey As String
Dim invcount As Long
Set uidoc = ws.currentdocument
lookupkey = uidoc.FieldGetText("key")
Set db = session.CurrentDatabase
Set view = db.GetView("(keylookup)")
Set doc = view.GetDocumentByKey(lookupkey, True)
invcount = doc.invcount(0)
invcount = invcount + Clng(uidoc.FieldGetText("newamount"))
doc.invcount = invcount
Call doc.Save(True, True)
End Sub
Feedback response number WEBB8TMDFB created by ~Justin Chugeromanli on 04/23/2012